﻿CREATE VIEW [dbo].[ASMS_V_PackageInstanceItem]
	AS 
SELECT PII.*,
	PItem.[Name] as PackageItemName,
	PItem.[Type] as PackageItemType,
	PItem.[TagDataType] as PackageItemTagDataType,
	PItem.[TagData] as PackageItemTagData
FROM ASMS_PackageInstanceItem as PII
	left join ASMS_PackageItem as PItem on PItem.Id = PII.PackageItemId
